Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-3719

jBPM->Oracle->Simple process stays "InRunning Mode"

    XMLWordPrintable

Details

    Description

      Set jBPM to use oracle persistence
      Create a simple process (start task, script task(hello world), end terminate event)
      When runing through the jbpm-console, this process is always in running mode. the PROCESSINSTANCELOG entry never updates the "end_date".

      Doing the same on a jBPM->connected to SQL Server the process is tagged as completed.

      After checking the log file with "show_sql" turned on, I found out that is missing an update sql statement:

      SQL Server:
      ...

      14:21:08,374 INFO [stdout] (http--0.0.0.0-8080-3) Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=?

      14:21:08,393 INFO [stdout] (http--0.0.0.0-8080-3) Hibernate: update ProcessInstanceLog set end_date=?, processId=?, processInstanceId=?, start_date=? where id=?

      14:21:08,408 INFO [stdout] (http--0.0.0.0-8080-3) Hibernate: delete from ProcessInstanceInfo where InstanceId=? and OPTLOCK=?

      ...

      Oracle:

      13:54:14,926 INFO [stdout] (http-localhost-127.0.0.1-8080-2) Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=?

      13:54:15,133 INFO [stdout] (http-localhost-127.0.0.1-8080-2) Hibernate: delete from ProcessInstanceInfo where InstanceId=? and OPTLOCK=?

      Attachments

        Activity

          People

            marco.rietveld Marco Rietveld (Inactive)
            hugobap Hugo Baptista (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: